Problem Note 35637: Filters applied to OLAP-based SASĀ® Web Report Studio reports might not be applied to linked relational reports
Depending on which version of SAS Web Report Studio that you are running, filter information from an OLAP-based report might not be passed to a relational target report.
If you are running any version earlier than the second maintenance release for SAS 9.2 (TS2M2), then, when passing values from an OLAP-based report to a relational report, hidden (filtered out) information is unexpectedly included in the target report. For example, even if your OLAP table is filtered on Geography to show results only from Germany, the target report displays results that are based on all members of Geography. In addition, the results in the relational report are not restricted by any member-level security that might be applied to the OLAP report.
If you are running the second maintenance release for SAS 9.2 (TS2M2) or later, then you can associate hidden data items with prompts in the target report. So, for example, you can associate the Geography hierarchy with a prompt for Geography in the target report. For more information, see SAS Note 36631.
Operating System and Release Information
SAS System | SAS Web Report Studio | Microsoft Windows 2000 Advanced Server | 3.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Datacenter Server | 3.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Server | 3.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Professional | 3.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows NT Workstation | 3.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 4.2_M1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 4.2_M1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Standard Edition | 3.1 | 4.2_M1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows XP Professional | 3.1 | 4.2_M1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Windows Vista | 3.1 | 4.2_M1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
64-bit Enabled AIX | 3.1 | 4.2_M1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
64-bit Enabled Solaris | 3.1 | 4.2_M1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
HP-UX IPF | 3.1 | 4.2_M1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | medium |
Topic: | Data Management ==> Data Sources ==> Cubes Query and Reporting ==> Interactive Querying Query and Reporting ==> OLAP (Online Analytical Processing) Query and Reporting
|
Date Modified: | 2009-08-25 09:18:51 |
Date Created: | 2009-04-21 14:47:45 |